Имя: Пароль:
1C
1С v8
Подключение к dbf из 1С8 через драйвер фокспро 9
0 Loko
 
04.08.16
05:34
всем привет! есть старая прога (на фокспро), которая хранит информацию в дбф-файле. нужно настроить обмен: из 1С добавлять туда новые записи. проблема в том, что в этой файле есть memo поля. просто добавить через XBase не получается.
установили на серваке фокспро 9. пытаюсь подключится через ADODB к файлу. не получается.

СтрокаПодключения="DRIVER={Microsoft FoxPro VFP Driver (*.dbf)};SourceDB=\\1C\data\; SourceType=DBF; Exclusive=No;BackgroundFetch=Yes;Collate=Russian;Null=No;Deleted=Yes;";
Соединение = Новый COMОбъект("ADODB.Connection");
Соединение.Open(СтрокаПодключения);

Произошла исключительная ситуация (Microsoft OLE DB Provider for ODBC Drivers): [Microsoft][Диспетчер драйверов ODBC] Источник данных не найден и не указан драйвер, используемый по умолчанию



на серваке: windows (64) 2012. а odbc драйвер 32 разрядный может в этом проблема?
1 Loko
 
04.08.16
05:41
1С на серваке тоже 64 разрядная. когда в кофигураторе создаю новый внешний источник данных, видит только драйвер скл (64).
2 Loko
 
04.08.16
06:04
со своего компа windows 7 (32) получилось подключиться к дбф-ке. в т.ч. считать поля memo

ОлеДБ = Новый COMОбъект("ADODB.Connection");
Соединение = "Provider=VFPOLEDB.1;Data Source=" + КаталогИБ + ";Mode=ReadWrite;Collating Sequence=MACHINE";
ОлеДБ.Open(Соединение);
Command = Новый COMОбъект("ADODB.Command");
Command.ActiveConnection = ОлеДБ;
ТекстЗапроса = "
|select  *
|from sf01
|";
Command.CommandText = ТекстЗапроса;    
RecordSet = Новый COMОбъект("ADODB.RecordSet");    
RecordSet = Command.Execute();

вопрос 1: в чем разница между первым моим подключением (через драйвер) и нынешним (через провайдер)?
вопрос 2. все таки дело в разрядности виндовса? на серваке не работает также.
3 Loko
 
04.08.16
06:04
вопрос 3. как сделать запись в дбф-ку эту?
4 Kandellaster
 
04.08.16
06:10
скормить запросик с INSERT в Command
5 Loko
 
04.08.16
06:17
(4) запрос - это просто чтение файла. а мне нужно добавить новую запись.
6 Гобсек
 
04.08.16
06:19
Если создать файл dbf средствами 1С, то любая версия foxpro прочитает его без проблем.
7 Kandellaster
 
04.08.16
06:24
(5)
СтрокаЗапрос = "INSERT INTO tablename
VALUES ('значение', 'значение', 'значение');"
Command.CommandText = СтрокаЗапрос;    
RecordSet = Новый COMОбъект("ADODB.RecordSet");    
RecordSet = Command.Execute();

и таки не сработает штоле?
8 Loko
 
04.08.16
06:26
(6) вся проблема с полями memo. не работает 1С с этими полями.
9 Loko
 
04.08.16
06:26
(7) попробую. спасибо
10 NorthWind
 
04.08.16
06:28
(0) разница в том, что в первом случае вы пытаетесь использовать провайдер для odbc, который, в свою очередь, должен читать файл через драйвер odbc. Во втором случае вы используете провайдер visual fox pro, который работает с файлом напрямую.
11 NorthWind
 
04.08.16
06:30
Битность провайдеров должна совпадать с битностью процесса. Т.е. для сервака надо найти 64-битные провайдеры
12 NorthWind
 
04.08.16
06:31
или поставить 32-битный сервак, что вряд ли правильно
13 Loko
 
04.08.16
06:31
(10) ок. понял. спасибо.
а на сервере не работает именно из-за разрядности?
вообще в природе есть фокс про 64 для виндовс сервер 2012?
14 NorthWind
 
04.08.16
06:32
А провайдер Access фокспрошные файлы не ест? Он на МС 64-битный лежит...
15 NorthWind
 
04.08.16
06:37
Вообще поскольку ADO/OLEDB технология от Майкрософт, то я там бы и поискал провайдеров, могут быть вполне
16 Гобсек
 
04.08.16
06:38
(13)В нулевые годы Microsoft заявила, что разрабатывать 64-разрядную версию foxpro считает нецелесообразным и тем самым похоронила foxpro.
17 Loko
 
04.08.16
06:39
(14) смотрю на серваке в администрировании "Источники данных ODBC (64-разрядная версия)" там в драйверах только SQL Server стоит.
18 Loko
 
04.08.16
06:42
(7) ошибку выдает:
Произошла исключительная ситуация (Microsoft OLE DB Provider for Visual FoxPro): Must specify additional parameters.
19 Loko
 
04.08.16
06:51
(7) а, понял. я там наименования полей не указал. только значения.
20 Loko
 
04.08.16
07:47
(7) не идет все равно. не добавляется запись. видимо, как понимаю надо описать типы полей. Как это сделать?
21 Loko
 
04.08.16
07:56
Произошла исключительная ситуация (Microsoft OLE DB Provider for Visual FoxPro): Data type mismatch.
22 Горогуля
 
04.08.16
08:02
покажи уже какие значения и куда пытаешься писать
23 Loko
 
04.08.16
08:05

Tamil Sex Wap95com Work [FAST]

Tamil WAP95.com's exploration of work relationships and romantic storylines offers a captivating glimpse into the intertwining of personal and professional lives. By navigating these themes with sensitivity and creativity, the platform not only entertains but also invites its audience to reflect on their own experiences and societal norms. As we continue to navigate the complexities of modern life, the stories told on platforms like Tamil WAP95.com serve as a mirror to our society, challenging us to think more deeply about love, work, and the connections that enrich our lives.

Navigating the Modern Workplace: Love and Life in Tamil Digital Stories

The digital landscape of Tamil storytelling is evolving, moving away from traditional family dramas toward more relatable, urban settings. One of the most popular themes currently trending across platforms like Wattpad India and Pratilipi Tamil is the intersection of high-stakes work environments and complex romantic storylines. The Rise of the "Office Romance"

In modern Tamil fiction, the "office" is no longer just a background; it’s a character itself. Storylines often focus on the power dynamics between leads—such as the classic "stern CEO" and the "ambitious newcomer". These stories explore how professional respect can slowly transform into personal intimacy, often complicated by corporate rivalry or "enemies-to-lovers" tropes. Key Themes in Modern Tamil Workplace Romance

The Power Dynamic: Many stories delve into the tension of forced proximity, where characters must navigate their growing attraction while maintaining professional boundaries.

Healing Through Connection: A common narrative arc involves a character who is "broken" or guarded by past trauma finding a safe space and emotional healing through a colleague's support.

Urban Realism: Unlike village-based tales, these stories often highlight the fast-paced life of cities like Chennai or Bengaluru, focusing on the struggle to balance a demanding career with a meaningful relationship. Must-Read Recommendations

If you're looking for high-quality Tamil romantic content that captures these workplace vibes, consider exploring these popular types of stories: Tamil - LimynoPhilip - Wattpad

In contemporary Tamil cinema and digital storytelling, the line between work relationships and romantic storylines has evolved from traditional "office romances" into complex explorations of professional ambition and emotional intimacy. The Shift in Narrative

Modern Tamil narratives (often discussed on platforms like wap95) have moved away from the "boss-employee" clichés. Instead, they focus on:

Creative Collaboration: Protagonists often bond over shared passions—be it in tech startups, media houses, or artistic ventures—making the professional success as vital as the romantic payoff.

Equal Footing: There is a growing emphasis on "Power Couples" where both partners navigate corporate politics while maintaining their personal bond. Themes of Work-Life Balance

Recent storylines frequently tackle the tension between career goals and romantic stability. Common tropes include:

The Rivalry-to-Romance Arc: Competitors in the same field whose professional friction masks a deep intellectual attraction.

Support Systems: Characters who act as each other's "anchor" during high-stress work crises, proving that romance can be a catalyst for professional growth rather than a distraction. Cultural Impact

These stories resonate because they reflect the reality of the modern Tamil youth—navigating urban workspaces where the workplace is the primary social hub. By blending professional stakes with romantic tension, creators deliver a more grounded, relatable experience that mirrors the challenges of 21st-century dating.

Workplace romance and romantic storylines in Tamil literature—often found on popular web novel platforms—frequently blend modern corporate settings with traditional emotional values. While "wap95.com" specifically is a legacy mobile portal formerly known for hosting e-books and novels, the broader genre of Tamil office romance thrives on several tropes. Core Themes in Tamil Workplace Romance

Romantic storylines in this genre typically revolve around the tension between professional power dynamics and personal feelings.

The "Cold Boss" vs. "Bubbly Employee": A dominant trope where a strict, billionaire, or high-achieving male lead (often an "Anti-hero") clashes with a cheerful, hardworking female subordinate.

Enemies-to-Lovers: Colleagues competing for the same promotion or coming from rival companies who eventually find common ground through shared work projects.

Secret Relationships: Couples who must hide their romance to maintain professional decorum or because of strict office policies.

Marriage of Convenience (Corporate Edition): Storylines where two individuals enter a legal union to save a business or fulfill a family legacy, only to fall in love while working together. Recommended Authors & Novels

Many popular Tamil novelists focus heavily on these romantic dynamics, with their works widely available on digital platforms: Notable Workplace/Romantic Works Ramanichandran Avanukku Nan Azhagu, Thodukodugal Classic romance with deep emotional bonds. Aadvika Pommu Un Parvayile Ennai Uraya Vaithaai Contemporary workplace romance. Muthulakshmi Raghavan Sollamale Poopuththadhe, Azhagana Ratchasiye Intense, multi-part romantic sagas. Thenaruvi Tamil Novels Arakkanin Koondu Kili Aval Anti-hero and dark romantic themes. Plot Elements for a "Proper Piece"

If you are developing a storyline for this genre, consider these essential elements:

The Meet-Cute: Usually involves a high-pressure office situation, such as an elevator encounter or a critical presentation mishap.

Professional Rivalry: Use work assignments as a way to create forced proximity.

Cultural Context: Incorporating family expectations and "marriage of convenience" can add traditional Tamil flavor to a modern corporate setting.

Emotional Anchors: Much like modern Tamil films like Thiruchitrambalam, the best stories often feature one character being an "emotional anchor" for the other during professional stress. 17 Workplace Romance Books to Fuel your Office Crush

Since Wap95.com primarily focuses on mobile downloads (ringtones, songs, video clips, and short stories), its romantic workplace narratives are typically concise, dramatic, and tailored for quick consumption. tamil sex wap95com work


Instead of pirated versions from sites like tamil wap95, support the industry by watching these workplace‑romance Tamil stories on:


If you’d like me to rewrite this as a comparison between how pirated‑site summaries distort these storylines vs. how they actually play out in legal versions, I’m happy to do that. Just let me know.

Tamil WAP95Com: A Popular Platform for Entertainment

Tamil WAP95Com is a well-known online platform that caters to the entertainment needs of Tamil-speaking audiences worldwide. The website has gained significant popularity over the years, offering a wide range of content, including news, movies, TV shows, music, and more.

Work Relationships and Storylines

The platform often features stories, movies, and TV shows that explore various themes, including work relationships and romantic storylines. These storylines often revolve around the lives of common people, showcasing their struggles, passions, and relationships.

In many Tamil movies and TV shows, work relationships are portrayed as an essential aspect of life, highlighting the importance of teamwork, dedication, and professionalism. The storylines often depict characters navigating their careers, facing challenges, and developing strong bonds with their colleagues.

Romantic storylines are also a staple of Tamil entertainment, with many movies and TV shows featuring love stories that blossom in the workplace or through social interactions. These storylines often explore themes of love, heartbreak, and relationships, providing audiences with relatable and engaging content.

Exploring Complex Relationships

Tamil WAP95Com's content often delves into complex relationships, showcasing the intricacies of human emotions and interactions. The platform's storylines may explore themes such as:

By exploring these themes, Tamil WAP95Com provides audiences with thought-provoking content that resonates with their experiences and emotions.

Diverse Range of Content

Tamil WAP95Com offers a diverse range of content, catering to different interests and preferences. The platform features:

With its diverse range of content, Tamil WAP95Com has become a go-to platform for Tamil-speaking audiences worldwide, providing a one-stop solution for their entertainment needs.

In conclusion, Tamil WAP95Com is a popular online platform that offers a wide range of content, including movies, TV shows, music, and news. The platform's storylines often explore themes of work relationships, romantic relationships, and complex human emotions, providing audiences with relatable and engaging content.

"Wap95.com" appears to be a website commonly associated with hosting or downloading Tamil content, including films and serials. Reviews for romantic storylines and workplace relationships often found on such platforms typically center on recent Tamil cinema or web series trends

For 2026, a major romantic release discussed in Tamil reviews is the film (alternatively titled Nadhigalilae Neeradum Sooriyan in some contexts) Core Themes in Recent Tamil Romantic Storylines Gen-Z & 2K Love Dynamics : Many recent reviews, such as those from Tamil Movie Review on Facebook Abishan Jeevinth

, highlight a shift toward "Gen-Z love language," focusing on relatable dialogues and the "magic in chaos" found in modern relationships Workplace Relationships : Titles like Couple Friendly (2026) and Emakku Thozhil Romance

explore romance within professional or urban settings, often blending comedy with the complexities of modern dating Toxic vs. Healthy Relationships

: There is an increasing focus on distinguishing between "pookie" (cute) moments and "toxic" relationship patterns, as seen in deep-dive reviews like those for the film Critical Reception Highlights Typical Review Consensus First Half

Often praised for being "well-written and well-staged" with strong character agency Second Half

Frequently criticized for being "slightly predictable" or relying on "cliché" resolutions Performances

Reviews generally highlight natural chemistry between leads, especially in films featuring Anaswara Rajan Abishan Jeevinth Soundtrack work by composers like Sean Roldan is noted for adding emotional depth to romantic narratives

For detailed breakdowns of specific scenes or character arcs, communities on Reddit's r/kollywood

provide "megathreads" where users discuss whether these stories feel authentic or overly melodramatic or a breakdown of a particular web series hosted on that site?

While "wap95.com" (specifically tamilwap95.com ) is primarily known in digital spaces as a platform for downloading Tamil media such as ringtones and MP3s, it often hosts or serves as a portal for web-based "hot stories" and amateur fiction. A paper exploring work relationships and romantic storylines in this context would likely focus on the "pulp" or digital-native fiction popular in the Tamil web sphere. Paper Title:

Power and Passion in Digital Tamil Spaces: A Study of Work-Life Romance Tropes on TamilWap95 1. Introduction

: The evolution of Tamil romance from classic print novels (e.g., Ramanichandran) to digital-only platforms like TamilWap, Wattpad, and WebNovel. Tamil WAP95

: To analyze how professional hierarchies and workplace settings serve as catalysts for romantic conflict and physical intimacy in amateur Tamil web fiction. 2. The Professional as Personal: Work Relationship Tropes

In these digital stories, the workplace is rarely about labor; it is a stage for power dynamics. Key archetypes include: The Cold CEO

: A recurring figure—often a wealthy, aloof, or "rude" male lead—who is "tamed" by a younger, often financially vulnerable female lead. Forced Proximity

: Situations where the protagonist must take a job (e.g., secretary, assistant, or nanny) to pay off family debts or medical bills, creating a high-stakes power imbalance. The Vengeful Deal

: Plotlines where a business arrangement or a short-term marriage contract is used to gain revenge on an ex-partner, blurring the line between professional "deals" and romantic reality. 3. Romantic Storyline Structures

The paper would examine standard narrative arcs found in this genre: Enemies-to-Lovers

: Initial professional friction or hatred that eventually transforms into intense attraction. Arranged Marriage to "Divine Love"

: Couples forced together by family or business who discover mutual respect and affection while living under the same roof. Unrequited Longing

: Portrayals of emotional turmoil where societal norms or professional barriers prevent characters from fulfilling their desires. 4. Themes of Agency and Taboo Financial Independence vs. Protection

: Themes often fluctuate between a female lead needing a "protector" and her gaining the power to "handle the expenses" herself. Hyper-masculinity and Dominance

: The use of "Alpha" tropes, where the male lead is hyper-masculine and possessive, a staple of digital erotic and romantic fiction. Exploration of Taboo

: Digital platforms often host more sexually explicit content than traditional media, exploring themes of physical intimacy and "forbidden" attractions that bypass mainstream censorship. 5. Conclusion

While "wap95.com" appears to be a domain commonly associated with localized file-sharing or entertainment portals, it does not currently host a widely recognized or official series of articles. However, the intersection of Tamil workplace culture, professional relationships, and romantic storylines is a rich theme frequently explored in modern Tamil cinema, literature, and digital media.

Below is an exploration of how these themes play out in contemporary Tamil narratives and real-world dynamics.

1. Navigating Work Relationships in Tamil Professional Settings

The modern Tamil workplace is often a blend of traditional values and global corporate standards. This creates a unique environment for professional relationships:

Hierarchical Respect: Traditional "respect for elders" often translates into a clear hierarchy in the office. Younger professionals navigate this by balancing their modern skill sets with cultural norms like maryadhai (respect).

The "Work Family" Concept: In many small-to-medium Tamil enterprises, the workplace is viewed as an extension of the family. This fosters deep loyalty but can also blur the lines between personal and professional boundaries.

Networking and Mentorship: In cities like Chennai or Coimbatore, mentorship often goes beyond technical advice, involving life guidance that reflects the community-oriented nature of the culture. 2. Romantic Storylines: From "Work Spouse" to Life Partner

Tamil pop culture (Kollywood) has increasingly moved away from "village-centric" romances toward "urban-professional" storylines. These narratives often highlight:

Shared Ambitions: Modern romantic arcs frequently feature couples who meet in high-pressure environments like IT parks or creative agencies. The attraction is built on mutual professional respect and shared intellectual goals.

Conflict of Interest: A popular trope involves the tension between a budding romance and professional competition. Stories often explore whether one partner (traditionally the woman, though this is changing) must sacrifice their career for the relationship.

The "Work Spouse" Dynamic: Tamil digital series frequently depict the "work best friend" or "work spouse"—a platonic but deeply intimate relationship that provides emotional support during long office hours. 3. Cultural Challenges in Workplace Romance

Despite the modernization of the workplace, certain cultural hurdles remain significant in Tamil-specific contexts:

Discretion and "Gossip": The fear of ooru enna pesum (what will people say) often leads couples to keep workplace romances strictly secret to avoid professional repercussions or family scrutiny.

Gender Dynamics: While more women are in leadership roles, societal expectations regarding domestic roles still influence how romantic storylines are written and perceived. Often, a "successful" storyline concludes with marriage, mirroring the high value placed on the institution in Tamil society.

Inter-caste and Religious Barriers: Even in progressive corporate settings, romantic storylines often confront the reality of family approval, which remains a cornerstone of Tamil relationship dynamics. 4. Key Tamil Vocabulary for Relationships

Understanding these relationships often requires knowing the specific nuances of the language: Instead of pirated versions from sites like tamil

Kadhali/Kadhalan: The formal terms for girlfriend and boyfriend.

Puridhal: Meaning "understanding," often cited as the most critical element in a successful Tamil workplace relationship.

Anbu: A deep, selfless love that is often the foundation of long-term romantic arcs.

Romantic Relationships at Work: Why Love Can Hurt | Request PDF

Exploring the Dynamics of Work Relationships and Romantic Storylines in Tamil Cinema: A Focus on WAP95.com

Tamil cinema, known for its rich storytelling and diverse themes, has often delved into the complexities of work relationships and romantic storylines, captivating audiences with its nuanced portrayal of love, friendship, and professional bonds. One intriguing aspect of this exploration is the way these themes are intertwined, creating narratives that resonate with viewers on multiple levels. WAP95.com, a platform presumably dedicated to the enthusiasts of Tamil cinema, seems like an apt starting point to dissect these themes, given the widespread interest in how workplaces can become the backdrop for romance, friendship, and sometimes, heartbreak.

The Evolution of Work Relationships in Tamil Cinema

Historically, Tamil cinema has portrayed workplaces as environments where characters not only grow professionally but also navigate personal relationships. These settings range from corporate offices to small-town commercial establishments, each offering a unique canvas for storytelling. The evolution of these portrayals reflects societal changes, from the traditional office romances to more contemporary themes of workplace harassment, professional rivalry, and the challenges faced by women in the workforce.

Romantic Storylines: A Core Element

Romance has been an integral part of Tamil cinema, often finding a way into narratives through various means, including but not limited to, office settings. The workplace romance, a genre that has been explored extensively, presents a compelling dynamic. It allows for a natural progression of relationships, as characters find common ground in their professional endeavors, leading to deeper connections. These storylines are crafted to evoke emotions, making audiences invest in the characters' journeys.

The Intersection of Work and Romance

The intersection of work relationships and romantic storylines offers a rich area of exploration. WAP95.com, as a presumed hub for discussions and analyses of Tamil cinema, could provide insights into how these themes are received and interpreted by fans. The platform might highlight how certain movies use workplace settings to challenge traditional romantic narratives, introducing elements of realism and relatability.

Notable Examples

Several Tamil movies have successfully woven these themes into their narratives. For instance:

Conclusion

The exploration of work relationships and romantic storylines in Tamil cinema, as potentially discussed on platforms like WAP95.com, reveals a complex interplay of themes that resonate with audiences. These narratives not only entertain but also provide a mirror to society, reflecting the evolving dynamics of professional and personal relationships. Through its nuanced storytelling, Tamil cinema continues to engage viewers, offering insights into the human experience that are both profound and relatable.

The Blurred Lines of Love and Work: Exploring Tamil WAP95.com's Take on Work Relationships and Romantic Storylines

In the vast and vibrant landscape of Indian entertainment, Tamil WAP95.com has carved out a niche for itself by delivering engaging content that resonates with a wide audience. Among its diverse offerings, the platform has gained significant attention for its portrayal of work relationships and romantic storylines, often blurring the lines between professional and personal lives. This article aims to explore how Tamil WAP95.com navigates these themes, reflecting societal norms and sparking conversations about love, work, and everything in between.

A feudal remnant in modern attire: the owner’s son joins as a "management trainee" while the heroine, a self-taught coder, has worked for five years. He is arrogant; she is brilliant. The romance blooms when he is humbled by her work ethic. This storyline often features a pivotal scene in the server room.

1. The Office Rivals-to-Lovers

2. The Boss-Secretary Dynamic

3. The Colleague Secret Crush

4. The Return of the Ex (as a coworker)


We analyzed a purposive sample of 40 romance-themed stories/audio clips from wap95.com archives (2012–2018), supplemented by 15 user discussion threads. Narrative analysis focused on:

As of 2025, Tamil wap95com remains a nostalgic yet evolving platform. While newer apps like MX Player and Aha offer high-definition office romances, wap95com’s charm lies in its guerrilla storytelling. The work relationships portrayed here are not aspirational—they are real. They include the grime of the morning commute, the boredom of Excel sheets, and the quiet miracle of finding love between two Zoom calls.

We can expect more hybrid formats: audio dramas that link to YouTube trailers, and possibly, the platform’s first original "work romance" web series, produced entirely through user crowdfunding.

You might ask: Why not Netflix or Hotstar? The answer lies in accessibility and rawness.

24 Горогуля
 
04.08.16
08:08
такое впечатление, что сплошь строки пытаешься писать
25 Loko
 
04.08.16
08:10
(24) т.е. только строку надо в кавычках? число без? а мемо и булево?
26 NorthWind
 
04.08.16
08:10
(17) ну не стоит - найдите и поставьте
27 Loko
 
04.08.16
08:13
(26) в (16) написали, что нету 64-ой
28 Горогуля
 
04.08.16
08:13
(25) не скажу. 'false' - ну явно строка же ;)
29 NorthWind
 
04.08.16
08:15
(27) посмотрите в сторону провайдера для Access, вполне может быть что он делает то что вам надо. Он 64-битный - есть, скачивается с MS бесплатно
30 Loko
 
04.08.16
08:17
(28) точно .f. или .t. надо
31 Loko
 
04.08.16
08:17
(29) ок
32 Loko
 
04.08.16
08:19
в общем, получилось добавить запись) неправильно указывал значения. строка в одинарных кавычках, число без кавычек через точку в дробной части, булево - .f. или .t.

теперь осталось разобраться с разрядностью...
33 Горогуля
 
04.08.16
08:20
>просто добавить через XBase не получается.
оно как-то аргументирует?
34 Loko
 
04.08.16
08:22
(33) XBase не работает с типом поля memo
35 Kandellaster
 
04.08.16
08:28
каким боком у тебя там улануде ?))
36 Loko
 
04.08.16
08:36
(35) улан-удЭЭЭЭЭЭ. живу здесь
37 Loko
 
04.08.16
08:37
еще вопрос возник. а есть какие-нить механизмы блокировки дбф-файла в момент когда я записи свои буду добавлять?
38 Kandellaster
 
04.08.16
08:38
(36) я тоже там, живу
39 Гобсек
 
04.08.16
08:42
(37)Если мне память не изменяет, то foxpro при начале добавления записи автоматически делает блокировку заголовка и снимает по окончании. По логике в твоем случае эту работу автоматически должен делать драйвер.
40 Loko
 
04.08.16
08:43
(39) ок
41 Loko
 
04.08.16
09:08
пробую через акцес:
ОлеДБ = Новый COMОбъект("ADODB.Connection");
Соединение = "Provider=Microsoft.Ace.OLEDB.12.0;Data Source=" + КаталогИБ + ";Mode=ReadWrite;Collating Sequence=MACHINE";
ОлеДБ.Open(Соединение);

не открывается. ошибка:
{ВнешняяОбработка.ВыгрузкаВДБФ.Форма.Форма.Форма(80)}: Ошибка при вызове метода контекста (Open)
    ОлеДБ.Open(Соединение);
по причине:
Произошла исключительная ситуация (Microsoft Access Database Engine): Could not find installable ISAM.


провайдера мож неправильно указываю?
42 Горогуля
 
04.08.16
09:12
симптомы, причины, решения...
https://support.microsoft.com/en-us/kb/209805
43 Loko
 
04.08.16
09:17
да похоже нельзя открыть дбв через акцесс провайдер...
44 Loko
 
04.08.16
09:17
(43) дбф
45 Loko
 
04.08.16
09:26
СтрокаПодключения="DRIVER={Microsoft Access dBASE Driver (*.dbf, *.ndx, *.mdx)};SourceDB=\\1c\data\Bulat\; SourceType=DBF; Exclusive=No;BackgroundFetch=Yes;Collate=Russian;Null=No;Deleted=Yes;";
Соединение = Новый COMОбъект("ADODB.Connection");
Соединение.Open(СтрокаПодключения);

а вот так соединение проходит)

только новая ошибка синтаксиса при добавлении записи:

Syntax error (missing operator) in query expression '.f.'.
как булево записывается в акцесе?
46 ovrfox
 
04.08.16
09:28
(43) Можно, но только стандарта DBASE III (без полей memo)
47 SSSSS_AAAAA
 
04.08.16
09:31
Боже мой, сколько (уж извините за резкость) чуши на ровном месте...
1. Фокс только 32-битный  и дрова к нему тоже только 32-битные.
2. Список 32-битных дров на 64-юитных системах отдельный и никак не связан со списком 64-битных дров.
3. OLE DB Provider и ODBC - две разных технологии построения драйверов доступа к базам данных. конкретно для фокса ODBC драверы дрвнее мамонтов. Все фоксовые форматы дбф поддерживает только VFP OLE DB Provider.
4. Во спасение от будущих граблей :) - даты надо писать в формате {^yyyy-mm-dd}

В принципе, сего должно хватить для решения обсуждаемой пробемы. Разумеется, если это использовать с головой. :_
48 Loko
 
04.08.16
09:37
(47) это мы уже выяснили. с 32-х битного виндовса нормально подключаюсь через VFP OLE DB Provider. все работает.

ты уж извини меня неумного, но то, что ты перечислил - все это уже мы выяснили выше. конкретно как с сервера 64 разрядного подключится к дбф-ке?
49 SSSSS_AAAAA
 
04.08.16
09:37
Добавчик:
5. В подавляющем большинстве случаев сервер 1с 32-битный и потому во всех этих случаях ни о каких 64-битных дровах не может быть и речи.
50 Loko
 
04.08.16
09:39
(49) я сразу написал в первом посте что у нас сервер 1С 64 разрядный
51 SSSSS_AAAAA
 
04.08.16
09:43
(48) Да, похоже, таки еще не выяснили, раз такой вопрос задаешь.
Ну так и что непонятно из (49)? 64-битные приложения в принципе не умеют пользоваться 32-битными дровами.

Работать исключительно из 1с-вского клиента, даже если он и вместе сервером 1с на одной машине.
52 NorthWind
 
04.08.16
12:52
53 NorthWind
 
04.08.16
12:54
единственное что - я, честно сказать, уже плохо помню, получится там мемо-поля читать или нет.
54 SSSSS_AAAAA
 
04.08.16
13:36
(53) Получится, если строку коннекта сменит на рабочую с VFP OLE DB Provider.
55 Loko
 
05.08.16
04:40
(52) http://www.connectionstrings.com/using-jet-in-64-bit-environments/

как понял dbf не открываются через этот провайдер в 64-разрядной системе.
56 Loko
 
05.08.16
04:58
на локальной базе все норм работает.

на серваке:
{ВнешняяОбработка.ВыгрузкаВДБФ.Форма.Форма.Форма(32)}: Ошибка при вызове метода контекста (Open)
    DBConn.Open("Provider=Microsoft.Jet.OLEDB.4.0;" +
по причине:
Произошла исключительная ситуация (ADODB.Connection): Не удается найти указанный поставщик. Вероятно, он установлен неправильно.
57 Ёпрст
 
гуру
05.08.16
09:12
(56) дык поставь его, на серваке то. Чтоб хотя бы в udl был виден
58 Loko
 
08.08.16
09:40
подскажите синтаксис добавления даты в моем случае?

ДатаВ= Дата(Формат(DZAKL,"ДФ=dd.MM.yyyy"));

"INSERT INTO DOGOVOR VALUES ("+ДатаВ+")"

ошибка синтаксиса говорит
59 Ёпрст
 
гуру
08.08.16
09:43
Вот к такому виду приводи:
{d '2012-07-01'}
60 Loko
 
08.08.16
09:49
(59)т.е. дату мне так преобразовывать до инсерта:

Д = День(DZAKL);
М = Месяц(DZAKL);
Г = Год(DZAKL);

ДатаВ = "{d '"+Д+"-"+М+"-"+01+"'}";

?
61 Loko
 
08.08.16
09:49
ДатаВ = "{d '"+Д+"-"+М+"-"+Г+"'}";
т.е.
62 Loko
 
08.08.16
09:50
не идет так.

Произошла исключительная ситуация (Microsoft OLE DB Provider for Visual FoxPro): Произошла одна или несколько ошибок во время обработки команды.
63 Горогуля
 
08.08.16
09:50
видал в интернетах приколы по поводу даты. ^ перед или за { или что-то этакое.. ищи
64 Горогуля
 
08.08.16
09:50
+(63) в этой ветке тебе говорили даже
65 Loko
 
08.08.16
09:52
(64) ага в 47 увидел, попробую. спасиб
66 Горогуля
 
08.08.16
09:54
мущина! здесь же чат, а кто читает вчерашнее - тот лох
67 Loko
 
08.08.16
09:56
(66) ну не прочел. бывает.

запись, в общем, идет. но даты пустые...
68 Горогуля
 
08.08.16
09:57
(67) наверное, что-то не так, не?
69 Loko
 
08.08.16
10:00
ага, разобрался. числовые группы убрал в году)

все, работает. всем спасибо!
70 Горогуля
 
08.08.16
10:03
мда.. спасибо тебе (это не сарказм). у меня пока сохраняется вера в человечество. пока правильного намёка достаточно. и ответного "спасибо", конечно ;)
71 Ёпрст
 
гуру
08.08.16
10:10
(62) всё работает:

    КаталогИБ = "f:\";
    ОлеДБ = Новый COMОбъект("ADODB.Connection");
    Соединение = "Provider=VFPOLEDB.1;Data Source=" + КаталогИБ + ";Mode=ReadWrite;Collating Sequence=MACHINE";
    ОлеДБ.Open(Соединение);
    Комманд = Новый COMОбъект("ADODB.Command");
    Комманд.ActiveConnection = ОлеДБ;
    Комманд.CommandText = "insert into test ([date]) values ({d '2012-07-01'})";
      Комманд.Execute();


провайдер, этот, если че

https://www.microsoft.com/en-us/download/confirmation.aspx?id=14839
72 Loko
 
23.08.16
11:06
всем привет! это снова я)

в общем, получилось подключиться к дбф-ке через Provider = Microsoft.Ace.OLEDB.12.0 с сервака64. но проблема в том, что с мемо полями, как я понял, этот провайдер не работает (другие дбф-ки без мемо полей читает норм).

все-таки как Епрст подключается через Provider=VFPOLEDB.1? у меня упорно провайдера не видит. драйвер установлен также по ссылке как в (71).

скидываю скрин источников данных на серваке, смущает дата драйвера (1999 год). может в этом проблема?
http://upload.akusherstvo.ru/image1112606.png
73 Loko
 
23.08.16
11:07
вот здесь такая же проблема была, но там мемо полей не было. и тогда у Епрсты все ок было...
v8: как записать дбф через adodb.connection на х64 сервере
74 Ёпрст
 
гуру
23.08.16
11:08
(72) я хз, чего там у вас за серваки, у нас 2012 x64, хотя и на  2003 x64 hf,jnftn/
75 Loko
 
23.08.16
11:12
(74) а можете скрин сделать источников одбс как у меня в (72)?
Глупец, лишенный способности посмеяться над собой вместе с другими, не сможет долго выносить программирование. Фредерик Брукс-младший