Suche

About Us | Contact Us | Site Policies
Click Above to Support Our Sponsor!
Search
Find A Forum
Find An Expert
Home > Forums > Programmers > Languages
Visual Basic(Microsoft) -Version 5 & 6 (17469 members)
Database
How to make/edit DSN in code (API)
faq222-273
In the Form Code
Private Sub CreateSQLODBC()
’ This function setups a DSN common for remote
Database servers
’ Such as SQL or Oracle, keep in mind, this isnt a
complete listing of parameters
Dim DSN As String
Dim Server As String
Dim Address As String
Dim Database As String
Dim Description As String
Dim Security As String
’Basically the DSN Name you want to have
DSN = "DSN=" & Trim(txtDatabase.Text)
’The IP Addy of the server you want , if this is
a remote connection
Server = "SERVER=" & Trim(txtServer.Text)
’Same as above
Address = "ADDRESS=" & Trim(txtServer.Text)
’The name of the database as known by the DB
Server, such as SQL Server
HANDLE
PASSWORD
Remember Me
Forgot Password?
Join Us!
Keyword Search
Product Ratings
Browse Forums
Tell A Friend
Be Notified Of Responses
To Your Posts
Keyword Search
Turn Off Ad Banners
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Tell Others About Yourself
In Your Personal Profile
Best Of All, It's Free!
E-mail*
Handle
Select A Type
1 von 5
07.01.02 10:13