Board index » Visual Studio » DSN or DSNless connection?

DSN or DSNless connection?

Visual Studio22
I'm starting to move my VB6 application from Access to SQL Server. In the

beginning I'm going to use Access database with tables linked to SQL Server

tables. Then form by form are going to be moved to direct SQL Server

connection. When all of them are moved I delete Access. I have very weak

experience with SQL Server, so I even do not know advantages and

disadvantages of DSN and DSN less connections. I know that I have to learn

everything and I'm going to do that. But for the beginning could somebody

give me some suggestions regarding connection. What is better ? DSN or DSN

less?

Thank you

Vlad


-
 

Re:DSN or DSNless connection?

http://groups.google.com/groups?q" rel="nofollow" target="_blank">groups.google.com/groups=dsn+vs+dsn-less



--

-oj

www.rac4sql.net">www.rac4sql.net





"Vlad" <vovan.c@verizon.net>wrote in message

Quote
I'm starting to move my VB6 application from Access to SQL Server. In the

beginning I'm going to use Access database with tables linked to SQL

Server

tables. Then form by form are going to be moved to direct SQL Server

connection. When all of them are moved I delete Access. I have very weak

experience with SQL Server, so I even do not know advantages and

disadvantages of DSN and DSN less connections. I know that I have to learn

everything and I'm going to do that. But for the beginning could somebody

give me some suggestions regarding connection. What is better ? DSN or DSN

less?

Thank you

Vlad









-

Re:DSN or DSNless connection?

Thank you very much

Vlad

"oj" <nospam_ojngo@home.com>wrote in message

Quote
http://groups.google.com/groups?q" rel="nofollow" target="_blank">groups.google.com/groups=dsn+vs+dsn-less



--

-oj

www.rac4sql.net">www.rac4sql.net





"Vlad" <vovan.c@verizon.net>wrote in message

news:O5fGXDjAEHA.2180@TK2MSFTNGP09.phx.gbl...

>I'm starting to move my VB6 application from Access to SQL Server. In

the

>beginning I'm going to use Access database with tables linked to SQL

Server

>tables. Then form by form are going to be moved to direct SQL Server

>connection. When all of them are moved I delete Access. I have very weak

>experience with SQL Server, so I even do not know advantages and

>disadvantages of DSN and DSN less connections. I know that I have to

learn

>everything and I'm going to do that. But for the beginning could

somebody

>give me some suggestions regarding connection. What is better ? DSN or

DSN

>less?

>Thank you

>Vlad

>

>









-