ODBC to MSDE

I need to write a VB.Net application in VS.net 2003 that copies several tables from an ODBC data source to MSDE tables. I do not have Enterprise Manager or DTS to use. Is there an example of this in VS? I was hoping VS has some built in tools for this. If not, bulk Insert?

Help appreciated.
thanks,
FrankI would consider using MS Access for this, as it accesses both ODBC and MSDE data sources quite well (presuming this is not something that needs to run like a service).|||I ruled out Access because of several reasons. My next step is to schedule the scripts thru the SQL agent that MSDE comes with.

Help appreciated.
Thanks,
Frank

odbc link failed

Hello,
I have a windows SBS2003 server with msde installed.
I created some odbc datalinks in microsoft acces to one of my sql databases.
The links are ok end i can access the odbc links in microsoft acces on my
server.
Problem :
When i open the access database on my workstation and try to connect to one
of the odbc links, i getr the followin error.
ODBC-connection to 'SQL Server<servername> failed
Microsoft Access can't open the table in Datasheet View
Any suggestions?
Thank you,
Hi
Your MSDE instance was probably installed without the network protocols
See http://support.microsoft.com/?kbid=814130 on how to run svrnetcn.exe.
John
"Ponch" wrote:

> Hello,
> I have a windows SBS2003 server with msde installed.
> I created some odbc datalinks in microsoft acces to one of my sql databases.
> The links are ok end i can access the odbc links in microsoft acces on my
> server.
> Problem :
> When i open the access database on my workstation and try to connect to one
> of the odbc links, i getr the followin error.
> ODBC-connection to 'SQL Server<servername> failed
> Microsoft Access can't open the table in Datasheet View
> Any suggestions?
> Thank you,
>
>
|||Hello, Thanks for the tip, it solved my problem.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:4FD2882D-37A0-4EE7-B7A2-1C8BDEF50908@.microsoft.com...[vbcol=seagreen]
> Hi
> Your MSDE instance was probably installed without the network protocols
> See http://support.microsoft.com/?kbid=814130 on how to run svrnetcn.exe.
> John
> "Ponch" wrote:

odbc link failed

Hello,
I have a windows SBS2003 server with msde installed.
I created some odbc datalinks in microsoft acces to one of my sql databases.
The links are ok end i can access the odbc links in microsoft acces on my
server.
Problem :
When i open the access database on my workstation and try to connect to one
of the odbc links, i getr the followin error.
ODBC-connection to 'SQL Server<servername> failed
Microsoft Access can't open the table in Datasheet View
Any suggestions?
Thank you,Hi
Your MSDE instance was probably installed without the network protocols
See http://support.microsoft.com/?kbid=814130 on how to run svrnetcn.exe.
John
"Ponch" wrote:

> Hello,
> I have a windows SBS2003 server with msde installed.
> I created some odbc datalinks in microsoft acces to one of my sql database
s.
> The links are ok end i can access the odbc links in microsoft acces on my
> server.
> Problem :
> When i open the access database on my workstation and try to connect to on
e
> of the odbc links, i getr the followin error.
> ODBC-connection to 'SQL Server<servername> failed
> Microsoft Access can't open the table in Datasheet View
> Any suggestions?
> Thank you,
>
>|||Hello, Thanks for the tip, it solved my problem.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:4FD2882D-37A0-4EE7-B7A2-1C8BDEF50908@.microsoft.com...[vbcol=seagreen]
> Hi
> Your MSDE instance was probably installed without the network protocols
> See http://support.microsoft.com/?kbid=814130 on how to run svrnetcn.exe.
> John
> "Ponch" wrote:
>

odbc link failed

Hello,
I have a windows SBS2003 server with msde installed.
I created some odbc datalinks in microsoft acces to one of my sql databases.
The links are ok end i can access the odbc links in microsoft acces on my
server.
Problem :
When i open the access database on my workstation and try to connect to one
of the odbc links, i getr the followin error.
ODBC-connection to 'SQL Server<servername> failed
Microsoft Access can't open the table in Datasheet View
Any suggestions?
Thank you,Hi
Your MSDE instance was probably installed without the network protocols
See http://support.microsoft.com/?kbid=814130 on how to run svrnetcn.exe.
John
"Ponch" wrote:
> Hello,
> I have a windows SBS2003 server with msde installed.
> I created some odbc datalinks in microsoft acces to one of my sql databases.
> The links are ok end i can access the odbc links in microsoft acces on my
> server.
> Problem :
> When i open the access database on my workstation and try to connect to one
> of the odbc links, i getr the followin error.
> ODBC-connection to 'SQL Server<servername> failed
> Microsoft Access can't open the table in Datasheet View
> Any suggestions?
> Thank you,
>
>|||Hello, Thanks for the tip, it solved my problem.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:4FD2882D-37A0-4EE7-B7A2-1C8BDEF50908@.microsoft.com...
> Hi
> Your MSDE instance was probably installed without the network protocols
> See http://support.microsoft.com/?kbid=814130 on how to run svrnetcn.exe.
> John
> "Ponch" wrote:
>> Hello,
>> I have a windows SBS2003 server with msde installed.
>> I created some odbc datalinks in microsoft acces to one of my sql
>> databases.
>> The links are ok end i can access the odbc links in microsoft acces on my
>> server.
>> Problem :
>> When i open the access database on my workstation and try to connect to
>> one
>> of the odbc links, i getr the followin error.
>> ODBC-connection to 'SQL Server<servername> failed
>> Microsoft Access can't open the table in Datasheet View
>> Any suggestions?
>> Thank you,
>>
>>